ETL Jobs

Once the mappings are considered 'approved for coding', you can export the mappings as coding requirements to automatically generate ETL/ELT jobs. The ETL jobs can be generated for tools, such as Informatica PowerCenter, IBM DataStage, Microsoft SQL Server SSIS, Talend, and more.

1. Go to Application Menu > Data Catalog > Mapping Manager.
2. In the Workspace Mappings pane, right-click a project.
   
3. Click Execute Connector.
   The Connectors page appears.
   
4. On the Connectors page, go to relevant tab based on the export requirements and select an ETL tool.
   The screenshot below displays Azure Data Storage tab as an example.
   
5. Click .
   The Multi Mapping page appears.
   
6. Select the required mappings and click .
   The following notification appears.



7. Click the Download File hyperlink.
   The mapping specification is exported.